Unlimited Powerful Learning

PRESENTED BY : Shridhar

shridharkc93@gmail.co

m

Unlimited Powerful Learning

Installing Mysql on windows step by step :

Version Information :

•Mysql-8.1.0

Step 1 :

•Download the mysql community server from

MySQL official website.

•By clicking the above link you will see these

options

shown here.

•Select the version of mysql server and

operating

system .

•We will be using windows msi installer so click

on

the button besides windows (x86,64bit) MSI

installer.

INSTALLATION

Unlimited Powerful Learning

Step2 :

•Once you click on the download

option

you will be redirected to this page.

•You can login or sign up to your

account

and download the installer.

•In our case we will be skipping login

and

sign up by clicking on No thanks,

just

start my download.

Unlimited Powerful Learning

Step3 :

•Go to your download folder where you can see mysql installer, right click on it and click

install

to start the installation wizard.

Unlimited Powerful Learning

Step4 :

•MySQL server installation has

started.

•Remember to give necessary

permissions to start the

installation.

Unlimited Powerful Learning

Step5 :

•Read the license agreement and

and click I accept the terms in

the

license agreement and click next.

Unlimited Powerful Learning

Step6 :

•Choose setup type

•We will select Typical installation

and click on next.

Unlimited Powerful Learning

Step7 :

•Complete the mySQL server

setup

wizard by checking run MySQL

configurator and clicking finish.

Unlimited Powerful Learning

Step8 :

•We will be prompted with MySQL

configurator welcome page.

•To start MySQL configuration

click

next.

Unlimited Powerful Learning

Step9 :

•This window gives you different

type

of MySQL installation.

•Iam selecting development

computer

as Iam a developer so that I need

all

the products which help for my

development purposes.

•We will keep the connectivity to

the

default value. You can change it

according to your needs. And

click

next.

Unlimited Powerful Learning

Step10 :

•Here you can set your root

account

password

•If you wish to add new user

to the account, click on add

user

in MySQL user accounts

section.

and click next

Unlimited Powerful Learning

Step11 :

•Leave the windows services

to default and click next.

Unlimited Powerful Learning

Step12 :

•Keep the server file permissions

to

default and click next.

Unlimited Powerful Learning

Step13 :

•We will create sample world

database for testing, you can

delete

it later if you don’t need it.

Unlimited Powerful Learning

Step14 :

•Press Execute to apply

configurations

on the previous steps.

Unlimited Powerful Learning

Step15 :

•After execution, you can see

below

green colored ticks on every

config

option.

Unlimited Powerful Learning

Step16 :

•Click on finish and you got

your

MySQL server installed on

your

windows operating system.

Unlimited Powerful Learning

Testing :

•Search for MySQL in your

taskbar

search item, There you can

see all

MySQL products which

installed

•And click on MySQL command

line

client.

Unlimited Powerful Learning

Testing :

•After it will ask your MySQL

password to login, after login

you could see the MySQL

prompt

like shown here.

Unlimited Powerful Learning

Testing :

•MySQL comes along with

default

databases.

•we can see databases by using

show databases; command.